Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# V$MAP_FILE

`V$MAP_FILE` contains a list of all file mapping structures in the shared memory of the instance.

Column | Datatype | Description
--- | --- | ---
`FILE_MAP_IDX` | `NUMBER` | Index corresponding to file
`FILE_CFGID` | `VARCHAR2(256)` | Configuration ID: N/A if configuration ID is not supported
`FILE_STATUS` | `VARCHAR2(7)` | Status of the mapping information: `VALID` - file mapping information is latest `INVALID` - mapping needs to be refreshed
`FILE_NAME` | `VARCHAR2(256)` | Absolute file name
`FILE_TYPE` | `VARCHAR2(11)` | File type (`DATAFILE`, `SPFILE`, `TEMPFILE`, `CONTROLFILE`, `LOGFILE`, or `ARCHIVEFILE`)
`FILE_STRUCTURE` | `VARCHAR2(9)` | File structure (`FILE`, `RAWVOLUME`, `RAWDEVICE`, or `NONE`)
`FILE_SIZE` | `NUMBER` | File size in HKB (Half KB)
`FILE_NEXTS` | `NUMBER` | Number of file extents in the file (not necessarily the same as the number of file extents mapped)
`LIB_IDX` | `NUMBER` | Index of mapping library claiming ownership of the file